$connection = mysql_connect("localhost","indemand","T0utjaca1") or die("Unable to connect to SQL server");
mysql_select_db("sportspool_football") or die("Unable to select database");
$url = $_SERVER[REQUEST_URI];
$array = explode("/", $url);
$year = $array[4];
//once we've moved to the new template, hacks like this could be removed, if needed.
if ($year) { $extrapathing = "../"; }
?>
include('../../../includes/adHeader.php'); ?>
include ('../../../includes/login_tabs.php'); ?>
include('../../../includes/menu.php'); ?>
include('../../../includes/adMenu.php'); ?>
if ($year) { echo "$year "; } ?>Pro Bowl Rosters
Welcome to the if ($year) { echo "$year "; } ?>Pro Bowl information page.
if ($year) { echo " Find out who played in the $year NFL Pro Bowl. "; } else { echo " Find out who played in the Pro Bowl for any year. "; } ?>
include ("../pro_bowl.inc"); ?>
if ($year == "") {
echo "";
$count = 0;
$query = "select distinct year from zz_rosters_probowl order by year asc";
$query2 = mysql_query($query) or die("Select Failed!");
while ($query3 = mysql_fetch_array($query2)) {
$yeardisplay = $query3['year'];
if ($count == 0) { echo ""; }
if ($yeardisplay) {
echo "$yeardisplay Pro Bowl Roster | ";
$count++;
}
if ($count == 3) { echo "
"; $count = 0;}
}
echo "
";
} ?>
if ($year) { ?>
// Because of the lack of downloadable databases, only the used info has been entered for 2009 onwards.
// Use this for 2008 and earlier
if ($year < 2009) {
?>
Player: | Position: | Team: |
$query = "select * from zz_rosters_probowl where year = '$year' order by name asc";
$query2 = mysql_query($query) or die(mysql_error());
while ($query3 = mysql_fetch_array($query2)){
$name = $query3['name'];
$position = $query3['position']; $position = str_replace(" ","",$position);
if ($position == "QB") { $position = "Quarterback"; }
if ($position == "RB") { $position = "Running Back"; }
if ($position == "WR") { $position = "Wide Receiver"; }
if ($position == "TE") { $position = "Tight End"; }
if ($position == "OL") { $position = "Offensive Line"; }
if ($position == "DL") { $position = "Defensive Line"; }
if ($position == "LB") { $position = "Linebacker"; }
if ($position == "DB") { $position = "Defensive Back"; }
if ($position == "PK") { $position = "Kicker"; }
if ($position == "K") { $position = "Kicker"; }
if ($position == "P") { $position = "Punter"; }
if ($position == "FS") { $position = "Free Safety"; }
if ($position == "RDE") { $position = "Right Defensive End"; }
if ($position == "LDE") { $position = "Left Defensive End"; }
if ($position == "C") { $position = "Center"; }
if ($position == "LT") { $position = "Left Tackle"; }
if ($position == "RT") { $position = "Right Tackle"; }
if ($position == "SS") { $position = "Strong Safety"; }
if ($position == "MLB") { $position = "Middle Linebacker"; }
if ($position == "LG") { $position = "Left Guard"; }
if ($position == "RG") { $position = "Right Right"; }
if ($position == "RLB") { $position = "Right Linebacker"; }
if ($position == "LLB") { $position = "Left Linebacker"; }
if ($position == "RDT") { $position = "Right Defensive Tackle"; }
if ($position == "LDT") { $position = "Left Defensive Tackle"; }
if ($position == "RET") { $position = "Punt Return"; }
if ($position == "LOLB") { $position = "Left Offensive Linebacker"; }
if ($position == "ROLB") { $position = "Right Offensive Linebacker"; }
if ($position == "RCB") { $position = "Right Cornerback"; }
if ($position == "LCB") { $position = "Left Cornerback"; }
if ($position == "RILB") { $position = "Right Inside Linebacker"; }
if ($position == "LILB") { $position = "Left Inside Linebacker"; }
if ($position == "FB") { $position = "Fullback"; }
if ($position == "NT") { $position = "Nose Tackle"; }
$team = $query3['team']; $team = strtolower($team); $team=str_replace(" ","",$team);
if ($team == "bal") { $team = 'Baltimore Ravens'; }
if ($team == "crd") { $team = 'Arizona Cardinals'; }
if ($team == "ari") { $team = 'Arizona Cardinals'; }
if ($team == "buf") { $team = 'Buffalo Bills'; }
if ($team == "atl") { $team = 'Atlanta Falcons'; }
if ($team == "cin") { $team = 'Cincinnati Bengals'; }
if ($team == "car") { $team = 'Carolina Panthers'; }
if ($team == "cle") { $team = 'Cleveland Browns'; }
if ($team == "chi") { $team = 'Chicago Bears'; }
if ($team == "den") { $team = 'Denver Broncos'; }
if ($team == "dal") { $team = 'Dallas Cowboys'; }
if ($team == "hou") { $team = 'Houston Texans'; }
if ($team == "det") { $team = 'Detroit Lions'; }
if ($team == "ind") { $team = 'Indianapolis Colts'; }
if ($team == "gnb") { $team = 'Green Bay Packers'; }
if ($team == "jax") { $team = 'Jacksonville Jaguars'; }
if ($team == "min") { $team = 'Minnesota Vikings'; }
if ($team == "kan") { $team = 'Kansas City Chiefs'; }
if ($team == "nor") { $team = 'New Orleans Saints'; }
if ($team == "mia") { $team = 'Miami Dolphins'; }
if ($team == "nyg") { $team = 'New York Giants'; }
if ($team == "nwe") { $team = 'New England Patriots'; }
if ($team == "phi") { $team = 'Philadelphia Eagles'; }
if ($team == "nyj") { $team = 'New York Jets'; }
if ($team == "sfo") { $team = 'San Francisco 49ers'; }
if ($team == "oak") { $team = 'Oakland Raiders'; }
if ($team == "sea") { $team = 'Seattle Seahawks'; }
if ($team == "pit") { $team = 'Pittsburgh Steelers'; }
if ($team == "stl") { $team = 'St. Louis Rams'; }
if ($team == "sdg") { $team = 'San Diego Chargers'; }
if ($team == "tam") { $team = 'Tampa Bay Buccaneers'; }
if ($team == "ten") { $team = 'Tennessee Titans'; }
if ($team == "was") { $team = 'Washington Redskins'; }
echo "$name | $position | $team |
";
}
} // end of prior to 2009
if ($year > 2008) {
?>
AFC Roster
Offense |
Player: | Position: | Team: |
$query = "select * from zz_rosters_probowl where (year = '$year') and (representing = 'AFC') and (offordef = 'Offense') order by name asc";
$query2 = mysql_query($query) or die(mysql_error());
while ($query3 = mysql_fetch_array($query2)){
$name = $query3['name'];
$position = $query3['position'];
$team = $query3['team']; $team = strtolower($team); $team=str_replace(" ","",$team);
if ($team == "bal") { $team = 'Baltimore Ravens'; }
if ($team == "crd") { $team = 'Arizona Cardinals'; }
if ($team == "ari") { $team = 'Arizona Cardinals'; }
if ($team == "buf") { $team = 'Buffalo Bills'; }
if ($team == "atl") { $team = 'Atlanta Falcons'; }
if ($team == "cin") { $team = 'Cincinnati Bengals'; }
if ($team == "car") { $team = 'Carolina Panthers'; }
if ($team == "cle") { $team = 'Cleveland Browns'; }
if ($team == "chi") { $team = 'Chicago Bears'; }
if ($team == "den") { $team = 'Denver Broncos'; }
if ($team == "dal") { $team = 'Dallas Cowboys'; }
if ($team == "hou") { $team = 'Houston Texans'; }
if ($team == "det") { $team = 'Detroit Lions'; }
if ($team == "ind") { $team = 'Indianapolis Colts'; }
if ($team == "gnb") { $team = 'Green Bay Packers'; }
if ($team == "jax") { $team = 'Jacksonville Jaguars'; }
if ($team == "min") { $team = 'Minnesota Vikings'; }
if ($team == "kan") { $team = 'Kansas City Chiefs'; }
if ($team == "nor") { $team = 'New Orleans Saints'; }
if ($team == "mia") { $team = 'Miami Dolphins'; }
if ($team == "nyg") { $team = 'New York Giants'; }
if ($team == "nwe") { $team = 'New England Patriots'; }
if ($team == "phi") { $team = 'Philadelphia Eagles'; }
if ($team == "nyj") { $team = 'New York Jets'; }
if ($team == "sfo") { $team = 'San Francisco 49ers'; }
if ($team == "oak") { $team = 'Oakland Raiders'; }
if ($team == "sea") { $team = 'Seattle Seahawks'; }
if ($team == "pit") { $team = 'Pittsburgh Steelers'; }
if ($team == "stl") { $team = 'St. Louis Rams'; }
if ($team == "sdg") { $team = 'San Diego Chargers'; }
if ($team == "tam") { $team = 'Tampa Bay Buccaneers'; }
if ($team == "ten") { $team = 'Tennessee Titans'; }
if ($team == "was") { $team = 'Washington Redskins'; }
echo "$name | $position | $team |
";
} ?>
Defense |
Player: | Position: | Team: |
$query = "select * from zz_rosters_probowl where (year = '$year') and (representing = 'AFC') and (offordef = 'Defense') order by name asc";
$query2 = mysql_query($query) or die(mysql_error());
while ($query3 = mysql_fetch_array($query2)){
$name = $query3['name'];
$position = $query3['position'];
$team = $query3['team']; $team = strtolower($team); $team=str_replace(" ","",$team);
if ($team == "bal") { $team = 'Baltimore Ravens'; }
if ($team == "crd") { $team = 'Arizona Cardinals'; }
if ($team == "ari") { $team = 'Arizona Cardinals'; }
if ($team == "buf") { $team = 'Buffalo Bills'; }
if ($team == "atl") { $team = 'Atlanta Falcons'; }
if ($team == "cin") { $team = 'Cincinnati Bengals'; }
if ($team == "car") { $team = 'Carolina Panthers'; }
if ($team == "cle") { $team = 'Cleveland Browns'; }
if ($team == "chi") { $team = 'Chicago Bears'; }
if ($team == "den") { $team = 'Denver Broncos'; }
if ($team == "dal") { $team = 'Dallas Cowboys'; }
if ($team == "hou") { $team = 'Houston Texans'; }
if ($team == "det") { $team = 'Detroit Lions'; }
if ($team == "ind") { $team = 'Indianapolis Colts'; }
if ($team == "gnb") { $team = 'Green Bay Packers'; }
if ($team == "jax") { $team = 'Jacksonville Jaguars'; }
if ($team == "min") { $team = 'Minnesota Vikings'; }
if ($team == "kan") { $team = 'Kansas City Chiefs'; }
if ($team == "nor") { $team = 'New Orleans Saints'; }
if ($team == "mia") { $team = 'Miami Dolphins'; }
if ($team == "nyg") { $team = 'New York Giants'; }
if ($team == "nwe") { $team = 'New England Patriots'; }
if ($team == "phi") { $team = 'Philadelphia Eagles'; }
if ($team == "nyj") { $team = 'New York Jets'; }
if ($team == "sfo") { $team = 'San Francisco 49ers'; }
if ($team == "oak") { $team = 'Oakland Raiders'; }
if ($team == "sea") { $team = 'Seattle Seahawks'; }
if ($team == "pit") { $team = 'Pittsburgh Steelers'; }
if ($team == "stl") { $team = 'St. Louis Rams'; }
if ($team == "sdg") { $team = 'San Diego Chargers'; }
if ($team == "tam") { $team = 'Tampa Bay Buccaneers'; }
if ($team == "ten") { $team = 'Tennessee Titans'; }
if ($team == "was") { $team = 'Washington Redskins'; }
echo "$name | $position | $team |
";
} ?>
Special |
Player: | Position: | Team: |
$query = "select * from zz_rosters_probowl where (year = '$year') and (representing = 'AFC') and (offordef = 'Special') order by name asc";
$query2 = mysql_query($query) or die(mysql_error());
while ($query3 = mysql_fetch_array($query2)){
$name = $query3['name'];
$position = $query3['position'];
$team = $query3['team']; $team = strtolower($team); $team=str_replace(" ","",$team);
if ($team == "bal") { $team = 'Baltimore Ravens'; }
if ($team == "crd") { $team = 'Arizona Cardinals'; }
if ($team == "ari") { $team = 'Arizona Cardinals'; }
if ($team == "buf") { $team = 'Buffalo Bills'; }
if ($team == "atl") { $team = 'Atlanta Falcons'; }
if ($team == "cin") { $team = 'Cincinnati Bengals'; }
if ($team == "car") { $team = 'Carolina Panthers'; }
if ($team == "cle") { $team = 'Cleveland Browns'; }
if ($team == "chi") { $team = 'Chicago Bears'; }
if ($team == "den") { $team = 'Denver Broncos'; }
if ($team == "dal") { $team = 'Dallas Cowboys'; }
if ($team == "hou") { $team = 'Houston Texans'; }
if ($team == "det") { $team = 'Detroit Lions'; }
if ($team == "ind") { $team = 'Indianapolis Colts'; }
if ($team == "gnb") { $team = 'Green Bay Packers'; }
if ($team == "jax") { $team = 'Jacksonville Jaguars'; }
if ($team == "min") { $team = 'Minnesota Vikings'; }
if ($team == "kan") { $team = 'Kansas City Chiefs'; }
if ($team == "nor") { $team = 'New Orleans Saints'; }
if ($team == "mia") { $team = 'Miami Dolphins'; }
if ($team == "nyg") { $team = 'New York Giants'; }
if ($team == "nwe") { $team = 'New England Patriots'; }
if ($team == "phi") { $team = 'Philadelphia Eagles'; }
if ($team == "nyj") { $team = 'New York Jets'; }
if ($team == "sfo") { $team = 'San Francisco 49ers'; }
if ($team == "oak") { $team = 'Oakland Raiders'; }
if ($team == "sea") { $team = 'Seattle Seahawks'; }
if ($team == "pit") { $team = 'Pittsburgh Steelers'; }
if ($team == "stl") { $team = 'St. Louis Rams'; }
if ($team == "sdg") { $team = 'San Diego Chargers'; }
if ($team == "tam") { $team = 'Tampa Bay Buccaneers'; }
if ($team == "ten") { $team = 'Tennessee Titans'; }
if ($team == "was") { $team = 'Washington Redskins'; }
echo "$name | $position | $team |
";
} ?>
NFC Roster
Offense |
Player: | Position: | Team: |
$query = "select * from zz_rosters_probowl where (year = '$year') and (representing = 'NFC') and (offordef = 'Offense') order by name asc";
$query2 = mysql_query($query) or die(mysql_error());
while ($query3 = mysql_fetch_array($query2)){
$name = $query3['name'];
$position = $query3['position'];
$team = $query3['team']; $team = strtolower($team); $team=str_replace(" ","",$team);
if ($team == "bal") { $team = 'Baltimore Ravens'; }
if ($team == "crd") { $team = 'Arizona Cardinals'; }
if ($team == "ari") { $team = 'Arizona Cardinals'; }
if ($team == "buf") { $team = 'Buffalo Bills'; }
if ($team == "atl") { $team = 'Atlanta Falcons'; }
if ($team == "cin") { $team = 'Cincinnati Bengals'; }
if ($team == "car") { $team = 'Carolina Panthers'; }
if ($team == "cle") { $team = 'Cleveland Browns'; }
if ($team == "chi") { $team = 'Chicago Bears'; }
if ($team == "den") { $team = 'Denver Broncos'; }
if ($team == "dal") { $team = 'Dallas Cowboys'; }
if ($team == "hou") { $team = 'Houston Texans'; }
if ($team == "det") { $team = 'Detroit Lions'; }
if ($team == "ind") { $team = 'Indianapolis Colts'; }
if ($team == "gnb") { $team = 'Green Bay Packers'; }
if ($team == "jax") { $team = 'Jacksonville Jaguars'; }
if ($team == "min") { $team = 'Minnesota Vikings'; }
if ($team == "kan") { $team = 'Kansas City Chiefs'; }
if ($team == "nor") { $team = 'New Orleans Saints'; }
if ($team == "mia") { $team = 'Miami Dolphins'; }
if ($team == "nyg") { $team = 'New York Giants'; }
if ($team == "nwe") { $team = 'New England Patriots'; }
if ($team == "phi") { $team = 'Philadelphia Eagles'; }
if ($team == "nyj") { $team = 'New York Jets'; }
if ($team == "sfo") { $team = 'San Francisco 49ers'; }
if ($team == "oak") { $team = 'Oakland Raiders'; }
if ($team == "sea") { $team = 'Seattle Seahawks'; }
if ($team == "pit") { $team = 'Pittsburgh Steelers'; }
if ($team == "stl") { $team = 'St. Louis Rams'; }
if ($team == "sdg") { $team = 'San Diego Chargers'; }
if ($team == "tam") { $team = 'Tampa Bay Buccaneers'; }
if ($team == "ten") { $team = 'Tennessee Titans'; }
if ($team == "was") { $team = 'Washington Redskins'; }
echo "$name | $position | $team |
";
} ?>
Defense |
Player: | Position: | Team: |
$query = "select * from zz_rosters_probowl where (year = '$year') and (representing = 'NFC') and (offordef = 'Defense') order by name asc";
$query2 = mysql_query($query) or die(mysql_error());
while ($query3 = mysql_fetch_array($query2)){
$name = $query3['name'];
$position = $query3['position'];
$team = $query3['team']; $team = strtolower($team); $team=str_replace(" ","",$team);
if ($team == "bal") { $team = 'Baltimore Ravens'; }
if ($team == "crd") { $team = 'Arizona Cardinals'; }
if ($team == "ari") { $team = 'Arizona Cardinals'; }
if ($team == "buf") { $team = 'Buffalo Bills'; }
if ($team == "atl") { $team = 'Atlanta Falcons'; }
if ($team == "cin") { $team = 'Cincinnati Bengals'; }
if ($team == "car") { $team = 'Carolina Panthers'; }
if ($team == "cle") { $team = 'Cleveland Browns'; }
if ($team == "chi") { $team = 'Chicago Bears'; }
if ($team == "den") { $team = 'Denver Broncos'; }
if ($team == "dal") { $team = 'Dallas Cowboys'; }
if ($team == "hou") { $team = 'Houston Texans'; }
if ($team == "det") { $team = 'Detroit Lions'; }
if ($team == "ind") { $team = 'Indianapolis Colts'; }
if ($team == "gnb") { $team = 'Green Bay Packers'; }
if ($team == "jax") { $team = 'Jacksonville Jaguars'; }
if ($team == "min") { $team = 'Minnesota Vikings'; }
if ($team == "kan") { $team = 'Kansas City Chiefs'; }
if ($team == "nor") { $team = 'New Orleans Saints'; }
if ($team == "mia") { $team = 'Miami Dolphins'; }
if ($team == "nyg") { $team = 'New York Giants'; }
if ($team == "nwe") { $team = 'New England Patriots'; }
if ($team == "phi") { $team = 'Philadelphia Eagles'; }
if ($team == "nyj") { $team = 'New York Jets'; }
if ($team == "sfo") { $team = 'San Francisco 49ers'; }
if ($team == "oak") { $team = 'Oakland Raiders'; }
if ($team == "sea") { $team = 'Seattle Seahawks'; }
if ($team == "pit") { $team = 'Pittsburgh Steelers'; }
if ($team == "stl") { $team = 'St. Louis Rams'; }
if ($team == "sdg") { $team = 'San Diego Chargers'; }
if ($team == "tam") { $team = 'Tampa Bay Buccaneers'; }
if ($team == "ten") { $team = 'Tennessee Titans'; }
if ($team == "was") { $team = 'Washington Redskins'; }
echo "$name | $position | $team |
";
} ?>
Special |
Player: | Position: | Team: |
$query = "select * from zz_rosters_probowl where (year = '$year') and (representing = 'NFC') and (offordef = 'Special') order by name asc";
$query2 = mysql_query($query) or die(mysql_error());
while ($query3 = mysql_fetch_array($query2)){
$name = $query3['name'];
$position = $query3['position'];
$team = $query3['team']; $team = strtolower($team); $team=str_replace(" ","",$team);
if ($team == "bal") { $team = 'Baltimore Ravens'; }
if ($team == "crd") { $team = 'Arizona Cardinals'; }
if ($team == "ari") { $team = 'Arizona Cardinals'; }
if ($team == "buf") { $team = 'Buffalo Bills'; }
if ($team == "atl") { $team = 'Atlanta Falcons'; }
if ($team == "cin") { $team = 'Cincinnati Bengals'; }
if ($team == "car") { $team = 'Carolina Panthers'; }
if ($team == "cle") { $team = 'Cleveland Browns'; }
if ($team == "chi") { $team = 'Chicago Bears'; }
if ($team == "den") { $team = 'Denver Broncos'; }
if ($team == "dal") { $team = 'Dallas Cowboys'; }
if ($team == "hou") { $team = 'Houston Texans'; }
if ($team == "det") { $team = 'Detroit Lions'; }
if ($team == "ind") { $team = 'Indianapolis Colts'; }
if ($team == "gnb") { $team = 'Green Bay Packers'; }
if ($team == "jax") { $team = 'Jacksonville Jaguars'; }
if ($team == "min") { $team = 'Minnesota Vikings'; }
if ($team == "kan") { $team = 'Kansas City Chiefs'; }
if ($team == "nor") { $team = 'New Orleans Saints'; }
if ($team == "mia") { $team = 'Miami Dolphins'; }
if ($team == "nyg") { $team = 'New York Giants'; }
if ($team == "nwe") { $team = 'New England Patriots'; }
if ($team == "phi") { $team = 'Philadelphia Eagles'; }
if ($team == "nyj") { $team = 'New York Jets'; }
if ($team == "sfo") { $team = 'San Francisco 49ers'; }
if ($team == "oak") { $team = 'Oakland Raiders'; }
if ($team == "sea") { $team = 'Seattle Seahawks'; }
if ($team == "pit") { $team = 'Pittsburgh Steelers'; }
if ($team == "stl") { $team = 'St. Louis Rams'; }
if ($team == "sdg") { $team = 'San Diego Chargers'; }
if ($team == "tam") { $team = 'Tampa Bay Buccaneers'; }
if ($team == "ten") { $team = 'Tennessee Titans'; }
if ($team == "was") { $team = 'Washington Redskins'; }
echo "$name | $position | $team |
";
}
echo "
";
} // end of after 2009
} //end of year picked
?>
include('../../../includes/adBannerContent.php'); ?>
include('../../../includes/fans.php'); ?>
include('../../../includes/superbowl_history.php'); ?>
include('../../../includes/tabs.php'); ?>
include('../../../includes/blogPosts.php'); ?>
include('../../../includes/poll.php'); ?>
include('../../../includes/main_rings.php'); ?>
include('../../../includes/main_topvideo.php'); ?>
include('../../../includes/adSidebar1.php'); ?>
include('../../../includes/adSidebar2.php'); ?>
include('../../../includes/menuBottom.php'); ?>
include('../../../includes/footer.php'); ?>